if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GetDistinctInstitutions]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[GetDistinctInstitutions]

go
-- =======================================================================
-- Procedure Name: dbo.GetDistinctInstitutions
--
-- Author:      Arthur Bianchini
--
-- Create date: 5/13/2008
--
-- Description: Returns list of distinct institutions 
--
-- Parameters:  None
-- 
--------------------------------------------------------------------------
-- Date        Initials  Modification
--------------------------------------------------------------------------
-- 
-- =======================================================================
CREATE PROCEDURE [dbo].[GetDistinctInstitutions]
 
AS
BEGIN

SELECT
 1 as InstitutionID,
'BWH' as Institution,
'BWH'  as Description
UNION
SELECT
2 as InstitutionID,
'DFCI' as Institution,
'DFCI'  as Description
UNION
SELECT
3 as InstitutionID,
'DFPCC' as Institution,
'DFPCC'  as Description
UNION
SELECT 
4 as InstitutionID,
'FH' as Institution,
'FH'  as Description
UNION
SELECT
5 as InstitutionID,
'IHP' as Institution,
'IHP'  as Description
UNION
SELECT
6 as InstitutionID,
'MCL' as Institution,
'MCL'  as Description
UNION
SELECT
7 as InstitutionID,
'MGH' as Institution,
'MGH'  as Description
UNION
SELECT
8 as InstitutionID,
'NWH' as Institution,
'NWH'  as Description
UNION
SELECT
9 as InstitutionID,
'SRH' as Institution,
'SRH'  as Description
UNION
SELECT 
10 as InstitutionID,
'All' as Institution,
'All'  as Description
UNION
SELECT
11 as InstitutionID,
'All - excluding DFCI' as Institution,
'All - excluding DFCI'  as Description
ORDER BY Description
     
END